﻿IF EXISTS (SELECT * FROM sysobjects WHERE type = 'V' AND name = 'HazardousLocation_View')
BEGIN
  DROP  View HazardousLocation_View
END
GO
CREATE View HazardousLocation_View 
AS
SELECT A.*,B.EntName EnterpriseName,B.Addess FROM HazardousLocation A 
JOIN Hazard B ON A.EnterpriseID=B.EntID
GO 